package pojo;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class WlCommodityExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public WlCommodityExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(String value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(String value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(String value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(String value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(String value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(String value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLike(String value) {
            addCriterion("id like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotLike(String value) {
            addCriterion("id not like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<String> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<String> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(String value1, String value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(String value1, String value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andCategoryidIsNull() {
            addCriterion("categoryId is null");
            return (Criteria) this;
        }

        public Criteria andCategoryidIsNotNull() {
            addCriterion("categoryId is not null");
            return (Criteria) this;
        }

        public Criteria andCategoryidEqualTo(String value) {
            addCriterion("categoryId =", value, "categoryid");
            return (Criteria) this;
        }

        public Criteria andCategoryidNotEqualTo(String value) {
            addCriterion("categoryId <>", value, "categoryid");
            return (Criteria) this;
        }

        public Criteria andCategoryidGreaterThan(String value) {
            addCriterion("categoryId >", value, "categoryid");
            return (Criteria) this;
        }

        public Criteria andCategoryidGreaterThanOrEqualTo(String value) {
            addCriterion("categoryId >=", value, "categoryid");
            return (Criteria) this;
        }

        public Criteria andCategoryidLessThan(String value) {
            addCriterion("categoryId <", value, "categoryid");
            return (Criteria) this;
        }

        public Criteria andCategoryidLessThanOrEqualTo(String value) {
            addCriterion("categoryId <=", value, "categoryid");
            return (Criteria) this;
        }

        public Criteria andCategoryidLike(String value) {
            addCriterion("categoryId like", value, "categoryid");
            return (Criteria) this;
        }

        public Criteria andCategoryidNotLike(String value) {
            addCriterion("categoryId not like", value, "categoryid");
            return (Criteria) this;
        }

        public Criteria andCategoryidIn(List<String> values) {
            addCriterion("categoryId in", values, "categoryid");
            return (Criteria) this;
        }

        public Criteria andCategoryidNotIn(List<String> values) {
            addCriterion("categoryId not in", values, "categoryid");
            return (Criteria) this;
        }

        public Criteria andCategoryidBetween(String value1, String value2) {
            addCriterion("categoryId between", value1, value2, "categoryid");
            return (Criteria) this;
        }

        public Criteria andCategoryidNotBetween(String value1, String value2) {
            addCriterion("categoryId not between", value1, value2, "categoryid");
            return (Criteria) this;
        }

        public Criteria andCommoditynameIsNull() {
            addCriterion("commodityName is null");
            return (Criteria) this;
        }

        public Criteria andCommoditynameIsNotNull() {
            addCriterion("commodityName is not null");
            return (Criteria) this;
        }

        public Criteria andCommoditynameEqualTo(String value) {
            addCriterion("commodityName =", value, "commodityname");
            return (Criteria) this;
        }

        public Criteria andCommoditynameNotEqualTo(String value) {
            addCriterion("commodityName <>", value, "commodityname");
            return (Criteria) this;
        }

        public Criteria andCommoditynameGreaterThan(String value) {
            addCriterion("commodityName >", value, "commodityname");
            return (Criteria) this;
        }

        public Criteria andCommoditynameGreaterThanOrEqualTo(String value) {
            addCriterion("commodityName >=", value, "commodityname");
            return (Criteria) this;
        }

        public Criteria andCommoditynameLessThan(String value) {
            addCriterion("commodityName <", value, "commodityname");
            return (Criteria) this;
        }

        public Criteria andCommoditynameLessThanOrEqualTo(String value) {
            addCriterion("commodityName <=", value, "commodityname");
            return (Criteria) this;
        }

        public Criteria andCommoditynameLike(String value) {
            addCriterion("commodityName like", value, "commodityname");
            return (Criteria) this;
        }

        public Criteria andCommoditynameNotLike(String value) {
            addCriterion("commodityName not like", value, "commodityname");
            return (Criteria) this;
        }

        public Criteria andCommoditynameIn(List<String> values) {
            addCriterion("commodityName in", values, "commodityname");
            return (Criteria) this;
        }

        public Criteria andCommoditynameNotIn(List<String> values) {
            addCriterion("commodityName not in", values, "commodityname");
            return (Criteria) this;
        }

        public Criteria andCommoditynameBetween(String value1, String value2) {
            addCriterion("commodityName between", value1, value2, "commodityname");
            return (Criteria) this;
        }

        public Criteria andCommoditynameNotBetween(String value1, String value2) {
            addCriterion("commodityName not between", value1, value2, "commodityname");
            return (Criteria) this;
        }

        public Criteria andImagesIsNull() {
            addCriterion("images is null");
            return (Criteria) this;
        }

        public Criteria andImagesIsNotNull() {
            addCriterion("images is not null");
            return (Criteria) this;
        }

        public Criteria andImagesEqualTo(String value) {
            addCriterion("images =", value, "images");
            return (Criteria) this;
        }

        public Criteria andImagesNotEqualTo(String value) {
            addCriterion("images <>", value, "images");
            return (Criteria) this;
        }

        public Criteria andImagesGreaterThan(String value) {
            addCriterion("images >", value, "images");
            return (Criteria) this;
        }

        public Criteria andImagesGreaterThanOrEqualTo(String value) {
            addCriterion("images >=", value, "images");
            return (Criteria) this;
        }

        public Criteria andImagesLessThan(String value) {
            addCriterion("images <", value, "images");
            return (Criteria) this;
        }

        public Criteria andImagesLessThanOrEqualTo(String value) {
            addCriterion("images <=", value, "images");
            return (Criteria) this;
        }

        public Criteria andImagesLike(String value) {
            addCriterion("images like", value, "images");
            return (Criteria) this;
        }

        public Criteria andImagesNotLike(String value) {
            addCriterion("images not like", value, "images");
            return (Criteria) this;
        }

        public Criteria andImagesIn(List<String> values) {
            addCriterion("images in", values, "images");
            return (Criteria) this;
        }

        public Criteria andImagesNotIn(List<String> values) {
            addCriterion("images not in", values, "images");
            return (Criteria) this;
        }

        public Criteria andImagesBetween(String value1, String value2) {
            addCriterion("images between", value1, value2, "images");
            return (Criteria) this;
        }

        public Criteria andImagesNotBetween(String value1, String value2) {
            addCriterion("images not between", value1, value2, "images");
            return (Criteria) this;
        }

        public Criteria andPropertyIsNull() {
            addCriterion("property is null");
            return (Criteria) this;
        }

        public Criteria andPropertyIsNotNull() {
            addCriterion("property is not null");
            return (Criteria) this;
        }

        public Criteria andPropertyEqualTo(String value) {
            addCriterion("property =", value, "property");
            return (Criteria) this;
        }

        public Criteria andPropertyNotEqualTo(String value) {
            addCriterion("property <>", value, "property");
            return (Criteria) this;
        }

        public Criteria andPropertyGreaterThan(String value) {
            addCriterion("property >", value, "property");
            return (Criteria) this;
        }

        public Criteria andPropertyGreaterThanOrEqualTo(String value) {
            addCriterion("property >=", value, "property");
            return (Criteria) this;
        }

        public Criteria andPropertyLessThan(String value) {
            addCriterion("property <", value, "property");
            return (Criteria) this;
        }

        public Criteria andPropertyLessThanOrEqualTo(String value) {
            addCriterion("property <=", value, "property");
            return (Criteria) this;
        }

        public Criteria andPropertyLike(String value) {
            addCriterion("property like", value, "property");
            return (Criteria) this;
        }

        public Criteria andPropertyNotLike(String value) {
            addCriterion("property not like", value, "property");
            return (Criteria) this;
        }

        public Criteria andPropertyIn(List<String> values) {
            addCriterion("property in", values, "property");
            return (Criteria) this;
        }

        public Criteria andPropertyNotIn(List<String> values) {
            addCriterion("property not in", values, "property");
            return (Criteria) this;
        }

        public Criteria andPropertyBetween(String value1, String value2) {
            addCriterion("property between", value1, value2, "property");
            return (Criteria) this;
        }

        public Criteria andPropertyNotBetween(String value1, String value2) {
            addCriterion("property not between", value1, value2, "property");
            return (Criteria) this;
        }

        public Criteria andCommodityimagesIsNull() {
            addCriterion("commodityImages is null");
            return (Criteria) this;
        }

        public Criteria andCommodityimagesIsNotNull() {
            addCriterion("commodityImages is not null");
            return (Criteria) this;
        }

        public Criteria andCommodityimagesEqualTo(String value) {
            addCriterion("commodityImages =", value, "commodityimages");
            return (Criteria) this;
        }

        public Criteria andCommodityimagesNotEqualTo(String value) {
            addCriterion("commodityImages <>", value, "commodityimages");
            return (Criteria) this;
        }

        public Criteria andCommodityimagesGreaterThan(String value) {
            addCriterion("commodityImages >", value, "commodityimages");
            return (Criteria) this;
        }

        public Criteria andCommodityimagesGreaterThanOrEqualTo(String value) {
            addCriterion("commodityImages >=", value, "commodityimages");
            return (Criteria) this;
        }

        public Criteria andCommodityimagesLessThan(String value) {
            addCriterion("commodityImages <", value, "commodityimages");
            return (Criteria) this;
        }

        public Criteria andCommodityimagesLessThanOrEqualTo(String value) {
            addCriterion("commodityImages <=", value, "commodityimages");
            return (Criteria) this;
        }

        public Criteria andCommodityimagesLike(String value) {
            addCriterion("commodityImages like", value, "commodityimages");
            return (Criteria) this;
        }

        public Criteria andCommodityimagesNotLike(String value) {
            addCriterion("commodityImages not like", value, "commodityimages");
            return (Criteria) this;
        }

        public Criteria andCommodityimagesIn(List<String> values) {
            addCriterion("commodityImages in", values, "commodityimages");
            return (Criteria) this;
        }

        public Criteria andCommodityimagesNotIn(List<String> values) {
            addCriterion("commodityImages not in", values, "commodityimages");
            return (Criteria) this;
        }

        public Criteria andCommodityimagesBetween(String value1, String value2) {
            addCriterion("commodityImages between", value1, value2, "commodityimages");
            return (Criteria) this;
        }

        public Criteria andCommodityimagesNotBetween(String value1, String value2) {
            addCriterion("commodityImages not between", value1, value2, "commodityimages");
            return (Criteria) this;
        }

        public Criteria andOpriceIsNull() {
            addCriterion("oprice is null");
            return (Criteria) this;
        }

        public Criteria andOpriceIsNotNull() {
            addCriterion("oprice is not null");
            return (Criteria) this;
        }

        public Criteria andOpriceEqualTo(Integer value) {
            addCriterion("oprice =", value, "oprice");
            return (Criteria) this;
        }

        public Criteria andOpriceNotEqualTo(Integer value) {
            addCriterion("oprice <>", value, "oprice");
            return (Criteria) this;
        }

        public Criteria andOpriceGreaterThan(Integer value) {
            addCriterion("oprice >", value, "oprice");
            return (Criteria) this;
        }

        public Criteria andOpriceGreaterThanOrEqualTo(Integer value) {
            addCriterion("oprice >=", value, "oprice");
            return (Criteria) this;
        }

        public Criteria andOpriceLessThan(Integer value) {
            addCriterion("oprice <", value, "oprice");
            return (Criteria) this;
        }

        public Criteria andOpriceLessThanOrEqualTo(Integer value) {
            addCriterion("oprice <=", value, "oprice");
            return (Criteria) this;
        }

        public Criteria andOpriceIn(List<Integer> values) {
            addCriterion("oprice in", values, "oprice");
            return (Criteria) this;
        }

        public Criteria andOpriceNotIn(List<Integer> values) {
            addCriterion("oprice not in", values, "oprice");
            return (Criteria) this;
        }

        public Criteria andOpriceBetween(Integer value1, Integer value2) {
            addCriterion("oprice between", value1, value2, "oprice");
            return (Criteria) this;
        }

        public Criteria andOpriceNotBetween(Integer value1, Integer value2) {
            addCriterion("oprice not between", value1, value2, "oprice");
            return (Criteria) this;
        }

        public Criteria andCpriceIsNull() {
            addCriterion("cprice is null");
            return (Criteria) this;
        }

        public Criteria andCpriceIsNotNull() {
            addCriterion("cprice is not null");
            return (Criteria) this;
        }

        public Criteria andCpriceEqualTo(Integer value) {
            addCriterion("cprice =", value, "cprice");
            return (Criteria) this;
        }

        public Criteria andCpriceNotEqualTo(Integer value) {
            addCriterion("cprice <>", value, "cprice");
            return (Criteria) this;
        }

        public Criteria andCpriceGreaterThan(Integer value) {
            addCriterion("cprice >", value, "cprice");
            return (Criteria) this;
        }

        public Criteria andCpriceGreaterThanOrEqualTo(Integer value) {
            addCriterion("cprice >=", value, "cprice");
            return (Criteria) this;
        }

        public Criteria andCpriceLessThan(Integer value) {
            addCriterion("cprice <", value, "cprice");
            return (Criteria) this;
        }

        public Criteria andCpriceLessThanOrEqualTo(Integer value) {
            addCriterion("cprice <=", value, "cprice");
            return (Criteria) this;
        }

        public Criteria andCpriceIn(List<Integer> values) {
            addCriterion("cprice in", values, "cprice");
            return (Criteria) this;
        }

        public Criteria andCpriceNotIn(List<Integer> values) {
            addCriterion("cprice not in", values, "cprice");
            return (Criteria) this;
        }

        public Criteria andCpriceBetween(Integer value1, Integer value2) {
            addCriterion("cprice between", value1, value2, "cprice");
            return (Criteria) this;
        }

        public Criteria andCpriceNotBetween(Integer value1, Integer value2) {
            addCriterion("cprice not between", value1, value2, "cprice");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andMsstatusIsNull() {
            addCriterion("msStatus is null");
            return (Criteria) this;
        }

        public Criteria andMsstatusIsNotNull() {
            addCriterion("msStatus is not null");
            return (Criteria) this;
        }

        public Criteria andMsstatusEqualTo(Integer value) {
            addCriterion("msStatus =", value, "msstatus");
            return (Criteria) this;
        }

        public Criteria andMsstatusNotEqualTo(Integer value) {
            addCriterion("msStatus <>", value, "msstatus");
            return (Criteria) this;
        }

        public Criteria andMsstatusGreaterThan(Integer value) {
            addCriterion("msStatus >", value, "msstatus");
            return (Criteria) this;
        }

        public Criteria andMsstatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("msStatus >=", value, "msstatus");
            return (Criteria) this;
        }

        public Criteria andMsstatusLessThan(Integer value) {
            addCriterion("msStatus <", value, "msstatus");
            return (Criteria) this;
        }

        public Criteria andMsstatusLessThanOrEqualTo(Integer value) {
            addCriterion("msStatus <=", value, "msstatus");
            return (Criteria) this;
        }

        public Criteria andMsstatusIn(List<Integer> values) {
            addCriterion("msStatus in", values, "msstatus");
            return (Criteria) this;
        }

        public Criteria andMsstatusNotIn(List<Integer> values) {
            addCriterion("msStatus not in", values, "msstatus");
            return (Criteria) this;
        }

        public Criteria andMsstatusBetween(Integer value1, Integer value2) {
            addCriterion("msStatus between", value1, value2, "msstatus");
            return (Criteria) this;
        }

        public Criteria andMsstatusNotBetween(Integer value1, Integer value2) {
            addCriterion("msStatus not between", value1, value2, "msstatus");
            return (Criteria) this;
        }

        public Criteria andLikecountIsNull() {
            addCriterion("likeCount is null");
            return (Criteria) this;
        }

        public Criteria andLikecountIsNotNull() {
            addCriterion("likeCount is not null");
            return (Criteria) this;
        }

        public Criteria andLikecountEqualTo(Integer value) {
            addCriterion("likeCount =", value, "likecount");
            return (Criteria) this;
        }

        public Criteria andLikecountNotEqualTo(Integer value) {
            addCriterion("likeCount <>", value, "likecount");
            return (Criteria) this;
        }

        public Criteria andLikecountGreaterThan(Integer value) {
            addCriterion("likeCount >", value, "likecount");
            return (Criteria) this;
        }

        public Criteria andLikecountGreaterThanOrEqualTo(Integer value) {
            addCriterion("likeCount >=", value, "likecount");
            return (Criteria) this;
        }

        public Criteria andLikecountLessThan(Integer value) {
            addCriterion("likeCount <", value, "likecount");
            return (Criteria) this;
        }

        public Criteria andLikecountLessThanOrEqualTo(Integer value) {
            addCriterion("likeCount <=", value, "likecount");
            return (Criteria) this;
        }

        public Criteria andLikecountIn(List<Integer> values) {
            addCriterion("likeCount in", values, "likecount");
            return (Criteria) this;
        }

        public Criteria andLikecountNotIn(List<Integer> values) {
            addCriterion("likeCount not in", values, "likecount");
            return (Criteria) this;
        }

        public Criteria andLikecountBetween(Integer value1, Integer value2) {
            addCriterion("likeCount between", value1, value2, "likecount");
            return (Criteria) this;
        }

        public Criteria andLikecountNotBetween(Integer value1, Integer value2) {
            addCriterion("likeCount not between", value1, value2, "likecount");
            return (Criteria) this;
        }

        public Criteria andSharecountIsNull() {
            addCriterion("shareCount is null");
            return (Criteria) this;
        }

        public Criteria andSharecountIsNotNull() {
            addCriterion("shareCount is not null");
            return (Criteria) this;
        }

        public Criteria andSharecountEqualTo(Integer value) {
            addCriterion("shareCount =", value, "sharecount");
            return (Criteria) this;
        }

        public Criteria andSharecountNotEqualTo(Integer value) {
            addCriterion("shareCount <>", value, "sharecount");
            return (Criteria) this;
        }

        public Criteria andSharecountGreaterThan(Integer value) {
            addCriterion("shareCount >", value, "sharecount");
            return (Criteria) this;
        }

        public Criteria andSharecountGreaterThanOrEqualTo(Integer value) {
            addCriterion("shareCount >=", value, "sharecount");
            return (Criteria) this;
        }

        public Criteria andSharecountLessThan(Integer value) {
            addCriterion("shareCount <", value, "sharecount");
            return (Criteria) this;
        }

        public Criteria andSharecountLessThanOrEqualTo(Integer value) {
            addCriterion("shareCount <=", value, "sharecount");
            return (Criteria) this;
        }

        public Criteria andSharecountIn(List<Integer> values) {
            addCriterion("shareCount in", values, "sharecount");
            return (Criteria) this;
        }

        public Criteria andSharecountNotIn(List<Integer> values) {
            addCriterion("shareCount not in", values, "sharecount");
            return (Criteria) this;
        }

        public Criteria andSharecountBetween(Integer value1, Integer value2) {
            addCriterion("shareCount between", value1, value2, "sharecount");
            return (Criteria) this;
        }

        public Criteria andSharecountNotBetween(Integer value1, Integer value2) {
            addCriterion("shareCount not between", value1, value2, "sharecount");
            return (Criteria) this;
        }

        public Criteria andQrcodeIsNull() {
            addCriterion("qrCode is null");
            return (Criteria) this;
        }

        public Criteria andQrcodeIsNotNull() {
            addCriterion("qrCode is not null");
            return (Criteria) this;
        }

        public Criteria andQrcodeEqualTo(String value) {
            addCriterion("qrCode =", value, "qrcode");
            return (Criteria) this;
        }

        public Criteria andQrcodeNotEqualTo(String value) {
            addCriterion("qrCode <>", value, "qrcode");
            return (Criteria) this;
        }

        public Criteria andQrcodeGreaterThan(String value) {
            addCriterion("qrCode >", value, "qrcode");
            return (Criteria) this;
        }

        public Criteria andQrcodeGreaterThanOrEqualTo(String value) {
            addCriterion("qrCode >=", value, "qrcode");
            return (Criteria) this;
        }

        public Criteria andQrcodeLessThan(String value) {
            addCriterion("qrCode <", value, "qrcode");
            return (Criteria) this;
        }

        public Criteria andQrcodeLessThanOrEqualTo(String value) {
            addCriterion("qrCode <=", value, "qrcode");
            return (Criteria) this;
        }

        public Criteria andQrcodeLike(String value) {
            addCriterion("qrCode like", value, "qrcode");
            return (Criteria) this;
        }

        public Criteria andQrcodeNotLike(String value) {
            addCriterion("qrCode not like", value, "qrcode");
            return (Criteria) this;
        }

        public Criteria andQrcodeIn(List<String> values) {
            addCriterion("qrCode in", values, "qrcode");
            return (Criteria) this;
        }

        public Criteria andQrcodeNotIn(List<String> values) {
            addCriterion("qrCode not in", values, "qrcode");
            return (Criteria) this;
        }

        public Criteria andQrcodeBetween(String value1, String value2) {
            addCriterion("qrCode between", value1, value2, "qrcode");
            return (Criteria) this;
        }

        public Criteria andQrcodeNotBetween(String value1, String value2) {
            addCriterion("qrCode not between", value1, value2, "qrcode");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNull() {
            addCriterion("createTime is null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNotNull() {
            addCriterion("createTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeEqualTo(Date value) {
            addCriterion("createTime =", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotEqualTo(Date value) {
            addCriterion("createTime <>", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThan(Date value) {
            addCriterion("createTime >", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("createTime >=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThan(Date value) {
            addCriterion("createTime <", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThanOrEqualTo(Date value) {
            addCriterion("createTime <=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIn(List<Date> values) {
            addCriterion("createTime in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotIn(List<Date> values) {
            addCriterion("createTime not in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeBetween(Date value1, Date value2) {
            addCriterion("createTime between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotBetween(Date value1, Date value2) {
            addCriterion("createTime not between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andChannelIsNull() {
            addCriterion("channel is null");
            return (Criteria) this;
        }

        public Criteria andChannelIsNotNull() {
            addCriterion("channel is not null");
            return (Criteria) this;
        }

        public Criteria andChannelEqualTo(String value) {
            addCriterion("channel =", value, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelNotEqualTo(String value) {
            addCriterion("channel <>", value, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelGreaterThan(String value) {
            addCriterion("channel >", value, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelGreaterThanOrEqualTo(String value) {
            addCriterion("channel >=", value, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelLessThan(String value) {
            addCriterion("channel <", value, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelLessThanOrEqualTo(String value) {
            addCriterion("channel <=", value, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelLike(String value) {
            addCriterion("channel like", value, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelNotLike(String value) {
            addCriterion("channel not like", value, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelIn(List<String> values) {
            addCriterion("channel in", values, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelNotIn(List<String> values) {
            addCriterion("channel not in", values, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelBetween(String value1, String value2) {
            addCriterion("channel between", value1, value2, "channel");
            return (Criteria) this;
        }

        public Criteria andChannelNotBetween(String value1, String value2) {
            addCriterion("channel not between", value1, value2, "channel");
            return (Criteria) this;
        }

        public Criteria andCommoditycodeIsNull() {
            addCriterion("commodityCode is null");
            return (Criteria) this;
        }

        public Criteria andCommoditycodeIsNotNull() {
            addCriterion("commodityCode is not null");
            return (Criteria) this;
        }

        public Criteria andCommoditycodeEqualTo(String value) {
            addCriterion("commodityCode =", value, "commoditycode");
            return (Criteria) this;
        }

        public Criteria andCommoditycodeNotEqualTo(String value) {
            addCriterion("commodityCode <>", value, "commoditycode");
            return (Criteria) this;
        }

        public Criteria andCommoditycodeGreaterThan(String value) {
            addCriterion("commodityCode >", value, "commoditycode");
            return (Criteria) this;
        }

        public Criteria andCommoditycodeGreaterThanOrEqualTo(String value) {
            addCriterion("commodityCode >=", value, "commoditycode");
            return (Criteria) this;
        }

        public Criteria andCommoditycodeLessThan(String value) {
            addCriterion("commodityCode <", value, "commoditycode");
            return (Criteria) this;
        }

        public Criteria andCommoditycodeLessThanOrEqualTo(String value) {
            addCriterion("commodityCode <=", value, "commoditycode");
            return (Criteria) this;
        }

        public Criteria andCommoditycodeLike(String value) {
            addCriterion("commodityCode like", value, "commoditycode");
            return (Criteria) this;
        }

        public Criteria andCommoditycodeNotLike(String value) {
            addCriterion("commodityCode not like", value, "commoditycode");
            return (Criteria) this;
        }

        public Criteria andCommoditycodeIn(List<String> values) {
            addCriterion("commodityCode in", values, "commoditycode");
            return (Criteria) this;
        }

        public Criteria andCommoditycodeNotIn(List<String> values) {
            addCriterion("commodityCode not in", values, "commoditycode");
            return (Criteria) this;
        }

        public Criteria andCommoditycodeBetween(String value1, String value2) {
            addCriterion("commodityCode between", value1, value2, "commoditycode");
            return (Criteria) this;
        }

        public Criteria andCommoditycodeNotBetween(String value1, String value2) {
            addCriterion("commodityCode not between", value1, value2, "commoditycode");
            return (Criteria) this;
        }

        public Criteria andIntegralIsNull() {
            addCriterion("integral is null");
            return (Criteria) this;
        }

        public Criteria andIntegralIsNotNull() {
            addCriterion("integral is not null");
            return (Criteria) this;
        }

        public Criteria andIntegralEqualTo(Integer value) {
            addCriterion("integral =", value, "integral");
            return (Criteria) this;
        }

        public Criteria andIntegralNotEqualTo(Integer value) {
            addCriterion("integral <>", value, "integral");
            return (Criteria) this;
        }

        public Criteria andIntegralGreaterThan(Integer value) {
            addCriterion("integral >", value, "integral");
            return (Criteria) this;
        }

        public Criteria andIntegralGreaterThanOrEqualTo(Integer value) {
            addCriterion("integral >=", value, "integral");
            return (Criteria) this;
        }

        public Criteria andIntegralLessThan(Integer value) {
            addCriterion("integral <", value, "integral");
            return (Criteria) this;
        }

        public Criteria andIntegralLessThanOrEqualTo(Integer value) {
            addCriterion("integral <=", value, "integral");
            return (Criteria) this;
        }

        public Criteria andIntegralIn(List<Integer> values) {
            addCriterion("integral in", values, "integral");
            return (Criteria) this;
        }

        public Criteria andIntegralNotIn(List<Integer> values) {
            addCriterion("integral not in", values, "integral");
            return (Criteria) this;
        }

        public Criteria andIntegralBetween(Integer value1, Integer value2) {
            addCriterion("integral between", value1, value2, "integral");
            return (Criteria) this;
        }

        public Criteria andIntegralNotBetween(Integer value1, Integer value2) {
            addCriterion("integral not between", value1, value2, "integral");
            return (Criteria) this;
        }

        public Criteria andSalesIsNull() {
            addCriterion("sales is null");
            return (Criteria) this;
        }

        public Criteria andSalesIsNotNull() {
            addCriterion("sales is not null");
            return (Criteria) this;
        }

        public Criteria andSalesEqualTo(Integer value) {
            addCriterion("sales =", value, "sales");
            return (Criteria) this;
        }

        public Criteria andSalesNotEqualTo(Integer value) {
            addCriterion("sales <>", value, "sales");
            return (Criteria) this;
        }

        public Criteria andSalesGreaterThan(Integer value) {
            addCriterion("sales >", value, "sales");
            return (Criteria) this;
        }

        public Criteria andSalesGreaterThanOrEqualTo(Integer value) {
            addCriterion("sales >=", value, "sales");
            return (Criteria) this;
        }

        public Criteria andSalesLessThan(Integer value) {
            addCriterion("sales <", value, "sales");
            return (Criteria) this;
        }

        public Criteria andSalesLessThanOrEqualTo(Integer value) {
            addCriterion("sales <=", value, "sales");
            return (Criteria) this;
        }

        public Criteria andSalesIn(List<Integer> values) {
            addCriterion("sales in", values, "sales");
            return (Criteria) this;
        }

        public Criteria andSalesNotIn(List<Integer> values) {
            addCriterion("sales not in", values, "sales");
            return (Criteria) this;
        }

        public Criteria andSalesBetween(Integer value1, Integer value2) {
            addCriterion("sales between", value1, value2, "sales");
            return (Criteria) this;
        }

        public Criteria andSalesNotBetween(Integer value1, Integer value2) {
            addCriterion("sales not between", value1, value2, "sales");
            return (Criteria) this;
        }

        public Criteria andSalesinitialIsNull() {
            addCriterion("salesInitial is null");
            return (Criteria) this;
        }

        public Criteria andSalesinitialIsNotNull() {
            addCriterion("salesInitial is not null");
            return (Criteria) this;
        }

        public Criteria andSalesinitialEqualTo(Integer value) {
            addCriterion("salesInitial =", value, "salesinitial");
            return (Criteria) this;
        }

        public Criteria andSalesinitialNotEqualTo(Integer value) {
            addCriterion("salesInitial <>", value, "salesinitial");
            return (Criteria) this;
        }

        public Criteria andSalesinitialGreaterThan(Integer value) {
            addCriterion("salesInitial >", value, "salesinitial");
            return (Criteria) this;
        }

        public Criteria andSalesinitialGreaterThanOrEqualTo(Integer value) {
            addCriterion("salesInitial >=", value, "salesinitial");
            return (Criteria) this;
        }

        public Criteria andSalesinitialLessThan(Integer value) {
            addCriterion("salesInitial <", value, "salesinitial");
            return (Criteria) this;
        }

        public Criteria andSalesinitialLessThanOrEqualTo(Integer value) {
            addCriterion("salesInitial <=", value, "salesinitial");
            return (Criteria) this;
        }

        public Criteria andSalesinitialIn(List<Integer> values) {
            addCriterion("salesInitial in", values, "salesinitial");
            return (Criteria) this;
        }

        public Criteria andSalesinitialNotIn(List<Integer> values) {
            addCriterion("salesInitial not in", values, "salesinitial");
            return (Criteria) this;
        }

        public Criteria andSalesinitialBetween(Integer value1, Integer value2) {
            addCriterion("salesInitial between", value1, value2, "salesinitial");
            return (Criteria) this;
        }

        public Criteria andSalesinitialNotBetween(Integer value1, Integer value2) {
            addCriterion("salesInitial not between", value1, value2, "salesinitial");
            return (Criteria) this;
        }

        public Criteria andWarehousenameIsNull() {
            addCriterion("wareHouseName is null");
            return (Criteria) this;
        }

        public Criteria andWarehousenameIsNotNull() {
            addCriterion("wareHouseName is not null");
            return (Criteria) this;
        }

        public Criteria andWarehousenameEqualTo(String value) {
            addCriterion("wareHouseName =", value, "warehousename");
            return (Criteria) this;
        }

        public Criteria andWarehousenameNotEqualTo(String value) {
            addCriterion("wareHouseName <>", value, "warehousename");
            return (Criteria) this;
        }

        public Criteria andWarehousenameGreaterThan(String value) {
            addCriterion("wareHouseName >", value, "warehousename");
            return (Criteria) this;
        }

        public Criteria andWarehousenameGreaterThanOrEqualTo(String value) {
            addCriterion("wareHouseName >=", value, "warehousename");
            return (Criteria) this;
        }

        public Criteria andWarehousenameLessThan(String value) {
            addCriterion("wareHouseName <", value, "warehousename");
            return (Criteria) this;
        }

        public Criteria andWarehousenameLessThanOrEqualTo(String value) {
            addCriterion("wareHouseName <=", value, "warehousename");
            return (Criteria) this;
        }

        public Criteria andWarehousenameLike(String value) {
            addCriterion("wareHouseName like", value, "warehousename");
            return (Criteria) this;
        }

        public Criteria andWarehousenameNotLike(String value) {
            addCriterion("wareHouseName not like", value, "warehousename");
            return (Criteria) this;
        }

        public Criteria andWarehousenameIn(List<String> values) {
            addCriterion("wareHouseName in", values, "warehousename");
            return (Criteria) this;
        }

        public Criteria andWarehousenameNotIn(List<String> values) {
            addCriterion("wareHouseName not in", values, "warehousename");
            return (Criteria) this;
        }

        public Criteria andWarehousenameBetween(String value1, String value2) {
            addCriterion("wareHouseName between", value1, value2, "warehousename");
            return (Criteria) this;
        }

        public Criteria andWarehousenameNotBetween(String value1, String value2) {
            addCriterion("wareHouseName not between", value1, value2, "warehousename");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andEbayurlIsNull() {
            addCriterion("ebayUrl is null");
            return (Criteria) this;
        }

        public Criteria andEbayurlIsNotNull() {
            addCriterion("ebayUrl is not null");
            return (Criteria) this;
        }

        public Criteria andEbayurlEqualTo(String value) {
            addCriterion("ebayUrl =", value, "ebayurl");
            return (Criteria) this;
        }

        public Criteria andEbayurlNotEqualTo(String value) {
            addCriterion("ebayUrl <>", value, "ebayurl");
            return (Criteria) this;
        }

        public Criteria andEbayurlGreaterThan(String value) {
            addCriterion("ebayUrl >", value, "ebayurl");
            return (Criteria) this;
        }

        public Criteria andEbayurlGreaterThanOrEqualTo(String value) {
            addCriterion("ebayUrl >=", value, "ebayurl");
            return (Criteria) this;
        }

        public Criteria andEbayurlLessThan(String value) {
            addCriterion("ebayUrl <", value, "ebayurl");
            return (Criteria) this;
        }

        public Criteria andEbayurlLessThanOrEqualTo(String value) {
            addCriterion("ebayUrl <=", value, "ebayurl");
            return (Criteria) this;
        }

        public Criteria andEbayurlLike(String value) {
            addCriterion("ebayUrl like", value, "ebayurl");
            return (Criteria) this;
        }

        public Criteria andEbayurlNotLike(String value) {
            addCriterion("ebayUrl not like", value, "ebayurl");
            return (Criteria) this;
        }

        public Criteria andEbayurlIn(List<String> values) {
            addCriterion("ebayUrl in", values, "ebayurl");
            return (Criteria) this;
        }

        public Criteria andEbayurlNotIn(List<String> values) {
            addCriterion("ebayUrl not in", values, "ebayurl");
            return (Criteria) this;
        }

        public Criteria andEbayurlBetween(String value1, String value2) {
            addCriterion("ebayUrl between", value1, value2, "ebayurl");
            return (Criteria) this;
        }

        public Criteria andEbayurlNotBetween(String value1, String value2) {
            addCriterion("ebayUrl not between", value1, value2, "ebayurl");
            return (Criteria) this;
        }

        public Criteria andEbaypriceIsNull() {
            addCriterion("ebayPrice is null");
            return (Criteria) this;
        }

        public Criteria andEbaypriceIsNotNull() {
            addCriterion("ebayPrice is not null");
            return (Criteria) this;
        }

        public Criteria andEbaypriceEqualTo(Integer value) {
            addCriterion("ebayPrice =", value, "ebayprice");
            return (Criteria) this;
        }

        public Criteria andEbaypriceNotEqualTo(Integer value) {
            addCriterion("ebayPrice <>", value, "ebayprice");
            return (Criteria) this;
        }

        public Criteria andEbaypriceGreaterThan(Integer value) {
            addCriterion("ebayPrice >", value, "ebayprice");
            return (Criteria) this;
        }

        public Criteria andEbaypriceGreaterThanOrEqualTo(Integer value) {
            addCriterion("ebayPrice >=", value, "ebayprice");
            return (Criteria) this;
        }

        public Criteria andEbaypriceLessThan(Integer value) {
            addCriterion("ebayPrice <", value, "ebayprice");
            return (Criteria) this;
        }

        public Criteria andEbaypriceLessThanOrEqualTo(Integer value) {
            addCriterion("ebayPrice <=", value, "ebayprice");
            return (Criteria) this;
        }

        public Criteria andEbaypriceIn(List<Integer> values) {
            addCriterion("ebayPrice in", values, "ebayprice");
            return (Criteria) this;
        }

        public Criteria andEbaypriceNotIn(List<Integer> values) {
            addCriterion("ebayPrice not in", values, "ebayprice");
            return (Criteria) this;
        }

        public Criteria andEbaypriceBetween(Integer value1, Integer value2) {
            addCriterion("ebayPrice between", value1, value2, "ebayprice");
            return (Criteria) this;
        }

        public Criteria andEbaypriceNotBetween(Integer value1, Integer value2) {
            addCriterion("ebayPrice not between", value1, value2, "ebayprice");
            return (Criteria) this;
        }

        public Criteria andEbaynameIsNull() {
            addCriterion("ebayName is null");
            return (Criteria) this;
        }

        public Criteria andEbaynameIsNotNull() {
            addCriterion("ebayName is not null");
            return (Criteria) this;
        }

        public Criteria andEbaynameEqualTo(String value) {
            addCriterion("ebayName =", value, "ebayname");
            return (Criteria) this;
        }

        public Criteria andEbaynameNotEqualTo(String value) {
            addCriterion("ebayName <>", value, "ebayname");
            return (Criteria) this;
        }

        public Criteria andEbaynameGreaterThan(String value) {
            addCriterion("ebayName >", value, "ebayname");
            return (Criteria) this;
        }

        public Criteria andEbaynameGreaterThanOrEqualTo(String value) {
            addCriterion("ebayName >=", value, "ebayname");
            return (Criteria) this;
        }

        public Criteria andEbaynameLessThan(String value) {
            addCriterion("ebayName <", value, "ebayname");
            return (Criteria) this;
        }

        public Criteria andEbaynameLessThanOrEqualTo(String value) {
            addCriterion("ebayName <=", value, "ebayname");
            return (Criteria) this;
        }

        public Criteria andEbaynameLike(String value) {
            addCriterion("ebayName like", value, "ebayname");
            return (Criteria) this;
        }

        public Criteria andEbaynameNotLike(String value) {
            addCriterion("ebayName not like", value, "ebayname");
            return (Criteria) this;
        }

        public Criteria andEbaynameIn(List<String> values) {
            addCriterion("ebayName in", values, "ebayname");
            return (Criteria) this;
        }

        public Criteria andEbaynameNotIn(List<String> values) {
            addCriterion("ebayName not in", values, "ebayname");
            return (Criteria) this;
        }

        public Criteria andEbaynameBetween(String value1, String value2) {
            addCriterion("ebayName between", value1, value2, "ebayname");
            return (Criteria) this;
        }

        public Criteria andEbaynameNotBetween(String value1, String value2) {
            addCriterion("ebayName not between", value1, value2, "ebayname");
            return (Criteria) this;
        }

        public Criteria andTaobaourlIsNull() {
            addCriterion("taobaoUrl is null");
            return (Criteria) this;
        }

        public Criteria andTaobaourlIsNotNull() {
            addCriterion("taobaoUrl is not null");
            return (Criteria) this;
        }

        public Criteria andTaobaourlEqualTo(String value) {
            addCriterion("taobaoUrl =", value, "taobaourl");
            return (Criteria) this;
        }

        public Criteria andTaobaourlNotEqualTo(String value) {
            addCriterion("taobaoUrl <>", value, "taobaourl");
            return (Criteria) this;
        }

        public Criteria andTaobaourlGreaterThan(String value) {
            addCriterion("taobaoUrl >", value, "taobaourl");
            return (Criteria) this;
        }

        public Criteria andTaobaourlGreaterThanOrEqualTo(String value) {
            addCriterion("taobaoUrl >=", value, "taobaourl");
            return (Criteria) this;
        }

        public Criteria andTaobaourlLessThan(String value) {
            addCriterion("taobaoUrl <", value, "taobaourl");
            return (Criteria) this;
        }

        public Criteria andTaobaourlLessThanOrEqualTo(String value) {
            addCriterion("taobaoUrl <=", value, "taobaourl");
            return (Criteria) this;
        }

        public Criteria andTaobaourlLike(String value) {
            addCriterion("taobaoUrl like", value, "taobaourl");
            return (Criteria) this;
        }

        public Criteria andTaobaourlNotLike(String value) {
            addCriterion("taobaoUrl not like", value, "taobaourl");
            return (Criteria) this;
        }

        public Criteria andTaobaourlIn(List<String> values) {
            addCriterion("taobaoUrl in", values, "taobaourl");
            return (Criteria) this;
        }

        public Criteria andTaobaourlNotIn(List<String> values) {
            addCriterion("taobaoUrl not in", values, "taobaourl");
            return (Criteria) this;
        }

        public Criteria andTaobaourlBetween(String value1, String value2) {
            addCriterion("taobaoUrl between", value1, value2, "taobaourl");
            return (Criteria) this;
        }

        public Criteria andTaobaourlNotBetween(String value1, String value2) {
            addCriterion("taobaoUrl not between", value1, value2, "taobaourl");
            return (Criteria) this;
        }

        public Criteria andTaobaopriceIsNull() {
            addCriterion("taobaoPrice is null");
            return (Criteria) this;
        }

        public Criteria andTaobaopriceIsNotNull() {
            addCriterion("taobaoPrice is not null");
            return (Criteria) this;
        }

        public Criteria andTaobaopriceEqualTo(Integer value) {
            addCriterion("taobaoPrice =", value, "taobaoprice");
            return (Criteria) this;
        }

        public Criteria andTaobaopriceNotEqualTo(Integer value) {
            addCriterion("taobaoPrice <>", value, "taobaoprice");
            return (Criteria) this;
        }

        public Criteria andTaobaopriceGreaterThan(Integer value) {
            addCriterion("taobaoPrice >", value, "taobaoprice");
            return (Criteria) this;
        }

        public Criteria andTaobaopriceGreaterThanOrEqualTo(Integer value) {
            addCriterion("taobaoPrice >=", value, "taobaoprice");
            return (Criteria) this;
        }

        public Criteria andTaobaopriceLessThan(Integer value) {
            addCriterion("taobaoPrice <", value, "taobaoprice");
            return (Criteria) this;
        }

        public Criteria andTaobaopriceLessThanOrEqualTo(Integer value) {
            addCriterion("taobaoPrice <=", value, "taobaoprice");
            return (Criteria) this;
        }

        public Criteria andTaobaopriceIn(List<Integer> values) {
            addCriterion("taobaoPrice in", values, "taobaoprice");
            return (Criteria) this;
        }

        public Criteria andTaobaopriceNotIn(List<Integer> values) {
            addCriterion("taobaoPrice not in", values, "taobaoprice");
            return (Criteria) this;
        }

        public Criteria andTaobaopriceBetween(Integer value1, Integer value2) {
            addCriterion("taobaoPrice between", value1, value2, "taobaoprice");
            return (Criteria) this;
        }

        public Criteria andTaobaopriceNotBetween(Integer value1, Integer value2) {
            addCriterion("taobaoPrice not between", value1, value2, "taobaoprice");
            return (Criteria) this;
        }

        public Criteria andAuditstatusIsNull() {
            addCriterion("auditStatus is null");
            return (Criteria) this;
        }

        public Criteria andAuditstatusIsNotNull() {
            addCriterion("auditStatus is not null");
            return (Criteria) this;
        }

        public Criteria andAuditstatusEqualTo(Integer value) {
            addCriterion("auditStatus =", value, "auditstatus");
            return (Criteria) this;
        }

        public Criteria andAuditstatusNotEqualTo(Integer value) {
            addCriterion("auditStatus <>", value, "auditstatus");
            return (Criteria) this;
        }

        public Criteria andAuditstatusGreaterThan(Integer value) {
            addCriterion("auditStatus >", value, "auditstatus");
            return (Criteria) this;
        }

        public Criteria andAuditstatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("auditStatus >=", value, "auditstatus");
            return (Criteria) this;
        }

        public Criteria andAuditstatusLessThan(Integer value) {
            addCriterion("auditStatus <", value, "auditstatus");
            return (Criteria) this;
        }

        public Criteria andAuditstatusLessThanOrEqualTo(Integer value) {
            addCriterion("auditStatus <=", value, "auditstatus");
            return (Criteria) this;
        }

        public Criteria andAuditstatusIn(List<Integer> values) {
            addCriterion("auditStatus in", values, "auditstatus");
            return (Criteria) this;
        }

        public Criteria andAuditstatusNotIn(List<Integer> values) {
            addCriterion("auditStatus not in", values, "auditstatus");
            return (Criteria) this;
        }

        public Criteria andAuditstatusBetween(Integer value1, Integer value2) {
            addCriterion("auditStatus between", value1, value2, "auditstatus");
            return (Criteria) this;
        }

        public Criteria andAuditstatusNotBetween(Integer value1, Integer value2) {
            addCriterion("auditStatus not between", value1, value2, "auditstatus");
            return (Criteria) this;
        }

        public Criteria andPlaceoriginIsNull() {
            addCriterion("placeOrigin is null");
            return (Criteria) this;
        }

        public Criteria andPlaceoriginIsNotNull() {
            addCriterion("placeOrigin is not null");
            return (Criteria) this;
        }

        public Criteria andPlaceoriginEqualTo(String value) {
            addCriterion("placeOrigin =", value, "placeorigin");
            return (Criteria) this;
        }

        public Criteria andPlaceoriginNotEqualTo(String value) {
            addCriterion("placeOrigin <>", value, "placeorigin");
            return (Criteria) this;
        }

        public Criteria andPlaceoriginGreaterThan(String value) {
            addCriterion("placeOrigin >", value, "placeorigin");
            return (Criteria) this;
        }

        public Criteria andPlaceoriginGreaterThanOrEqualTo(String value) {
            addCriterion("placeOrigin >=", value, "placeorigin");
            return (Criteria) this;
        }

        public Criteria andPlaceoriginLessThan(String value) {
            addCriterion("placeOrigin <", value, "placeorigin");
            return (Criteria) this;
        }

        public Criteria andPlaceoriginLessThanOrEqualTo(String value) {
            addCriterion("placeOrigin <=", value, "placeorigin");
            return (Criteria) this;
        }

        public Criteria andPlaceoriginLike(String value) {
            addCriterion("placeOrigin like", value, "placeorigin");
            return (Criteria) this;
        }

        public Criteria andPlaceoriginNotLike(String value) {
            addCriterion("placeOrigin not like", value, "placeorigin");
            return (Criteria) this;
        }

        public Criteria andPlaceoriginIn(List<String> values) {
            addCriterion("placeOrigin in", values, "placeorigin");
            return (Criteria) this;
        }

        public Criteria andPlaceoriginNotIn(List<String> values) {
            addCriterion("placeOrigin not in", values, "placeorigin");
            return (Criteria) this;
        }

        public Criteria andPlaceoriginBetween(String value1, String value2) {
            addCriterion("placeOrigin between", value1, value2, "placeorigin");
            return (Criteria) this;
        }

        public Criteria andPlaceoriginNotBetween(String value1, String value2) {
            addCriterion("placeOrigin not between", value1, value2, "placeorigin");
            return (Criteria) this;
        }

        public Criteria andGenericattributeIsNull() {
            addCriterion("genericAttribute is null");
            return (Criteria) this;
        }

        public Criteria andGenericattributeIsNotNull() {
            addCriterion("genericAttribute is not null");
            return (Criteria) this;
        }

        public Criteria andGenericattributeEqualTo(String value) {
            addCriterion("genericAttribute =", value, "genericattribute");
            return (Criteria) this;
        }

        public Criteria andGenericattributeNotEqualTo(String value) {
            addCriterion("genericAttribute <>", value, "genericattribute");
            return (Criteria) this;
        }

        public Criteria andGenericattributeGreaterThan(String value) {
            addCriterion("genericAttribute >", value, "genericattribute");
            return (Criteria) this;
        }

        public Criteria andGenericattributeGreaterThanOrEqualTo(String value) {
            addCriterion("genericAttribute >=", value, "genericattribute");
            return (Criteria) this;
        }

        public Criteria andGenericattributeLessThan(String value) {
            addCriterion("genericAttribute <", value, "genericattribute");
            return (Criteria) this;
        }

        public Criteria andGenericattributeLessThanOrEqualTo(String value) {
            addCriterion("genericAttribute <=", value, "genericattribute");
            return (Criteria) this;
        }

        public Criteria andGenericattributeLike(String value) {
            addCriterion("genericAttribute like", value, "genericattribute");
            return (Criteria) this;
        }

        public Criteria andGenericattributeNotLike(String value) {
            addCriterion("genericAttribute not like", value, "genericattribute");
            return (Criteria) this;
        }

        public Criteria andGenericattributeIn(List<String> values) {
            addCriterion("genericAttribute in", values, "genericattribute");
            return (Criteria) this;
        }

        public Criteria andGenericattributeNotIn(List<String> values) {
            addCriterion("genericAttribute not in", values, "genericattribute");
            return (Criteria) this;
        }

        public Criteria andGenericattributeBetween(String value1, String value2) {
            addCriterion("genericAttribute between", value1, value2, "genericattribute");
            return (Criteria) this;
        }

        public Criteria andGenericattributeNotBetween(String value1, String value2) {
            addCriterion("genericAttribute not between", value1, value2, "genericattribute");
            return (Criteria) this;
        }

        public Criteria andSelleridIsNull() {
            addCriterion("sellerId is null");
            return (Criteria) this;
        }

        public Criteria andSelleridIsNotNull() {
            addCriterion("sellerId is not null");
            return (Criteria) this;
        }

        public Criteria andSelleridEqualTo(String value) {
            addCriterion("sellerId =", value, "sellerid");
            return (Criteria) this;
        }

        public Criteria andSelleridNotEqualTo(String value) {
            addCriterion("sellerId <>", value, "sellerid");
            return (Criteria) this;
        }

        public Criteria andSelleridGreaterThan(String value) {
            addCriterion("sellerId >", value, "sellerid");
            return (Criteria) this;
        }

        public Criteria andSelleridGreaterThanOrEqualTo(String value) {
            addCriterion("sellerId >=", value, "sellerid");
            return (Criteria) this;
        }

        public Criteria andSelleridLessThan(String value) {
            addCriterion("sellerId <", value, "sellerid");
            return (Criteria) this;
        }

        public Criteria andSelleridLessThanOrEqualTo(String value) {
            addCriterion("sellerId <=", value, "sellerid");
            return (Criteria) this;
        }

        public Criteria andSelleridLike(String value) {
            addCriterion("sellerId like", value, "sellerid");
            return (Criteria) this;
        }

        public Criteria andSelleridNotLike(String value) {
            addCriterion("sellerId not like", value, "sellerid");
            return (Criteria) this;
        }

        public Criteria andSelleridIn(List<String> values) {
            addCriterion("sellerId in", values, "sellerid");
            return (Criteria) this;
        }

        public Criteria andSelleridNotIn(List<String> values) {
            addCriterion("sellerId not in", values, "sellerid");
            return (Criteria) this;
        }

        public Criteria andSelleridBetween(String value1, String value2) {
            addCriterion("sellerId between", value1, value2, "sellerid");
            return (Criteria) this;
        }

        public Criteria andSelleridNotBetween(String value1, String value2) {
            addCriterion("sellerId not between", value1, value2, "sellerid");
            return (Criteria) this;
        }

        public Criteria andDeletestatusIsNull() {
            addCriterion("deleteStatus is null");
            return (Criteria) this;
        }

        public Criteria andDeletestatusIsNotNull() {
            addCriterion("deleteStatus is not null");
            return (Criteria) this;
        }

        public Criteria andDeletestatusEqualTo(Integer value) {
            addCriterion("deleteStatus =", value, "deletestatus");
            return (Criteria) this;
        }

        public Criteria andDeletestatusNotEqualTo(Integer value) {
            addCriterion("deleteStatus <>", value, "deletestatus");
            return (Criteria) this;
        }

        public Criteria andDeletestatusGreaterThan(Integer value) {
            addCriterion("deleteStatus >", value, "deletestatus");
            return (Criteria) this;
        }

        public Criteria andDeletestatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("deleteStatus >=", value, "deletestatus");
            return (Criteria) this;
        }

        public Criteria andDeletestatusLessThan(Integer value) {
            addCriterion("deleteStatus <", value, "deletestatus");
            return (Criteria) this;
        }

        public Criteria andDeletestatusLessThanOrEqualTo(Integer value) {
            addCriterion("deleteStatus <=", value, "deletestatus");
            return (Criteria) this;
        }

        public Criteria andDeletestatusIn(List<Integer> values) {
            addCriterion("deleteStatus in", values, "deletestatus");
            return (Criteria) this;
        }

        public Criteria andDeletestatusNotIn(List<Integer> values) {
            addCriterion("deleteStatus not in", values, "deletestatus");
            return (Criteria) this;
        }

        public Criteria andDeletestatusBetween(Integer value1, Integer value2) {
            addCriterion("deleteStatus between", value1, value2, "deletestatus");
            return (Criteria) this;
        }

        public Criteria andDeletestatusNotBetween(Integer value1, Integer value2) {
            addCriterion("deleteStatus not between", value1, value2, "deletestatus");
            return (Criteria) this;
        }

        public Criteria andWeightIsNull() {
            addCriterion("weight is null");
            return (Criteria) this;
        }

        public Criteria andWeightIsNotNull() {
            addCriterion("weight is not null");
            return (Criteria) this;
        }

        public Criteria andWeightEqualTo(Integer value) {
            addCriterion("weight =", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightNotEqualTo(Integer value) {
            addCriterion("weight <>", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightGreaterThan(Integer value) {
            addCriterion("weight >", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightGreaterThanOrEqualTo(Integer value) {
            addCriterion("weight >=", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightLessThan(Integer value) {
            addCriterion("weight <", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightLessThanOrEqualTo(Integer value) {
            addCriterion("weight <=", value, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightIn(List<Integer> values) {
            addCriterion("weight in", values, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightNotIn(List<Integer> values) {
            addCriterion("weight not in", values, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightBetween(Integer value1, Integer value2) {
            addCriterion("weight between", value1, value2, "weight");
            return (Criteria) this;
        }

        public Criteria andWeightNotBetween(Integer value1, Integer value2) {
            addCriterion("weight not between", value1, value2, "weight");
            return (Criteria) this;
        }

        public Criteria andTmpriceIsNull() {
            addCriterion("tmPrice is null");
            return (Criteria) this;
        }

        public Criteria andTmpriceIsNotNull() {
            addCriterion("tmPrice is not null");
            return (Criteria) this;
        }

        public Criteria andTmpriceEqualTo(Integer value) {
            addCriterion("tmPrice =", value, "tmprice");
            return (Criteria) this;
        }

        public Criteria andTmpriceNotEqualTo(Integer value) {
            addCriterion("tmPrice <>", value, "tmprice");
            return (Criteria) this;
        }

        public Criteria andTmpriceGreaterThan(Integer value) {
            addCriterion("tmPrice >", value, "tmprice");
            return (Criteria) this;
        }

        public Criteria andTmpriceGreaterThanOrEqualTo(Integer value) {
            addCriterion("tmPrice >=", value, "tmprice");
            return (Criteria) this;
        }

        public Criteria andTmpriceLessThan(Integer value) {
            addCriterion("tmPrice <", value, "tmprice");
            return (Criteria) this;
        }

        public Criteria andTmpriceLessThanOrEqualTo(Integer value) {
            addCriterion("tmPrice <=", value, "tmprice");
            return (Criteria) this;
        }

        public Criteria andTmpriceIn(List<Integer> values) {
            addCriterion("tmPrice in", values, "tmprice");
            return (Criteria) this;
        }

        public Criteria andTmpriceNotIn(List<Integer> values) {
            addCriterion("tmPrice not in", values, "tmprice");
            return (Criteria) this;
        }

        public Criteria andTmpriceBetween(Integer value1, Integer value2) {
            addCriterion("tmPrice between", value1, value2, "tmprice");
            return (Criteria) this;
        }

        public Criteria andTmpriceNotBetween(Integer value1, Integer value2) {
            addCriterion("tmPrice not between", value1, value2, "tmprice");
            return (Criteria) this;
        }

        public Criteria andJdpriceIsNull() {
            addCriterion("jdPrice is null");
            return (Criteria) this;
        }

        public Criteria andJdpriceIsNotNull() {
            addCriterion("jdPrice is not null");
            return (Criteria) this;
        }

        public Criteria andJdpriceEqualTo(Integer value) {
            addCriterion("jdPrice =", value, "jdprice");
            return (Criteria) this;
        }

        public Criteria andJdpriceNotEqualTo(Integer value) {
            addCriterion("jdPrice <>", value, "jdprice");
            return (Criteria) this;
        }

        public Criteria andJdpriceGreaterThan(Integer value) {
            addCriterion("jdPrice >", value, "jdprice");
            return (Criteria) this;
        }

        public Criteria andJdpriceGreaterThanOrEqualTo(Integer value) {
            addCriterion("jdPrice >=", value, "jdprice");
            return (Criteria) this;
        }

        public Criteria andJdpriceLessThan(Integer value) {
            addCriterion("jdPrice <", value, "jdprice");
            return (Criteria) this;
        }

        public Criteria andJdpriceLessThanOrEqualTo(Integer value) {
            addCriterion("jdPrice <=", value, "jdprice");
            return (Criteria) this;
        }

        public Criteria andJdpriceIn(List<Integer> values) {
            addCriterion("jdPrice in", values, "jdprice");
            return (Criteria) this;
        }

        public Criteria andJdpriceNotIn(List<Integer> values) {
            addCriterion("jdPrice not in", values, "jdprice");
            return (Criteria) this;
        }

        public Criteria andJdpriceBetween(Integer value1, Integer value2) {
            addCriterion("jdPrice between", value1, value2, "jdprice");
            return (Criteria) this;
        }

        public Criteria andJdpriceNotBetween(Integer value1, Integer value2) {
            addCriterion("jdPrice not between", value1, value2, "jdprice");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceIsNull() {
            addCriterion("purchasePrice is null");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceIsNotNull() {
            addCriterion("purchasePrice is not null");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceEqualTo(Integer value) {
            addCriterion("purchasePrice =", value, "purchaseprice");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceNotEqualTo(Integer value) {
            addCriterion("purchasePrice <>", value, "purchaseprice");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceGreaterThan(Integer value) {
            addCriterion("purchasePrice >", value, "purchaseprice");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceGreaterThanOrEqualTo(Integer value) {
            addCriterion("purchasePrice >=", value, "purchaseprice");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceLessThan(Integer value) {
            addCriterion("purchasePrice <", value, "purchaseprice");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceLessThanOrEqualTo(Integer value) {
            addCriterion("purchasePrice <=", value, "purchaseprice");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceIn(List<Integer> values) {
            addCriterion("purchasePrice in", values, "purchaseprice");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceNotIn(List<Integer> values) {
            addCriterion("purchasePrice not in", values, "purchaseprice");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceBetween(Integer value1, Integer value2) {
            addCriterion("purchasePrice between", value1, value2, "purchaseprice");
            return (Criteria) this;
        }

        public Criteria andPurchasepriceNotBetween(Integer value1, Integer value2) {
            addCriterion("purchasePrice not between", value1, value2, "purchaseprice");
            return (Criteria) this;
        }

        public Criteria andTbpriceIsNull() {
            addCriterion("tbPrice is null");
            return (Criteria) this;
        }

        public Criteria andTbpriceIsNotNull() {
            addCriterion("tbPrice is not null");
            return (Criteria) this;
        }

        public Criteria andTbpriceEqualTo(Integer value) {
            addCriterion("tbPrice =", value, "tbprice");
            return (Criteria) this;
        }

        public Criteria andTbpriceNotEqualTo(Integer value) {
            addCriterion("tbPrice <>", value, "tbprice");
            return (Criteria) this;
        }

        public Criteria andTbpriceGreaterThan(Integer value) {
            addCriterion("tbPrice >", value, "tbprice");
            return (Criteria) this;
        }

        public Criteria andTbpriceGreaterThanOrEqualTo(Integer value) {
            addCriterion("tbPrice >=", value, "tbprice");
            return (Criteria) this;
        }

        public Criteria andTbpriceLessThan(Integer value) {
            addCriterion("tbPrice <", value, "tbprice");
            return (Criteria) this;
        }

        public Criteria andTbpriceLessThanOrEqualTo(Integer value) {
            addCriterion("tbPrice <=", value, "tbprice");
            return (Criteria) this;
        }

        public Criteria andTbpriceIn(List<Integer> values) {
            addCriterion("tbPrice in", values, "tbprice");
            return (Criteria) this;
        }

        public Criteria andTbpriceNotIn(List<Integer> values) {
            addCriterion("tbPrice not in", values, "tbprice");
            return (Criteria) this;
        }

        public Criteria andTbpriceBetween(Integer value1, Integer value2) {
            addCriterion("tbPrice between", value1, value2, "tbprice");
            return (Criteria) this;
        }

        public Criteria andTbpriceNotBetween(Integer value1, Integer value2) {
            addCriterion("tbPrice not between", value1, value2, "tbprice");
            return (Criteria) this;
        }

        public Criteria andSortIsNull() {
            addCriterion("sort is null");
            return (Criteria) this;
        }

        public Criteria andSortIsNotNull() {
            addCriterion("sort is not null");
            return (Criteria) this;
        }

        public Criteria andSortEqualTo(Integer value) {
            addCriterion("sort =", value, "sort");
            return (Criteria) this;
        }

        public Criteria andSortNotEqualTo(Integer value) {
            addCriterion("sort <>", value, "sort");
            return (Criteria) this;
        }

        public Criteria andSortGreaterThan(Integer value) {
            addCriterion("sort >", value, "sort");
            return (Criteria) this;
        }

        public Criteria andSortGreaterThanOrEqualTo(Integer value) {
            addCriterion("sort >=", value, "sort");
            return (Criteria) this;
        }

        public Criteria andSortLessThan(Integer value) {
            addCriterion("sort <", value, "sort");
            return (Criteria) this;
        }

        public Criteria andSortLessThanOrEqualTo(Integer value) {
            addCriterion("sort <=", value, "sort");
            return (Criteria) this;
        }

        public Criteria andSortIn(List<Integer> values) {
            addCriterion("sort in", values, "sort");
            return (Criteria) this;
        }

        public Criteria andSortNotIn(List<Integer> values) {
            addCriterion("sort not in", values, "sort");
            return (Criteria) this;
        }

        public Criteria andSortBetween(Integer value1, Integer value2) {
            addCriterion("sort between", value1, value2, "sort");
            return (Criteria) this;
        }

        public Criteria andSortNotBetween(Integer value1, Integer value2) {
            addCriterion("sort not between", value1, value2, "sort");
            return (Criteria) this;
        }

        public Criteria andBrandnameIsNull() {
            addCriterion("brandName is null");
            return (Criteria) this;
        }

        public Criteria andBrandnameIsNotNull() {
            addCriterion("brandName is not null");
            return (Criteria) this;
        }

        public Criteria andBrandnameEqualTo(String value) {
            addCriterion("brandName =", value, "brandname");
            return (Criteria) this;
        }

        public Criteria andBrandnameNotEqualTo(String value) {
            addCriterion("brandName <>", value, "brandname");
            return (Criteria) this;
        }

        public Criteria andBrandnameGreaterThan(String value) {
            addCriterion("brandName >", value, "brandname");
            return (Criteria) this;
        }

        public Criteria andBrandnameGreaterThanOrEqualTo(String value) {
            addCriterion("brandName >=", value, "brandname");
            return (Criteria) this;
        }

        public Criteria andBrandnameLessThan(String value) {
            addCriterion("brandName <", value, "brandname");
            return (Criteria) this;
        }

        public Criteria andBrandnameLessThanOrEqualTo(String value) {
            addCriterion("brandName <=", value, "brandname");
            return (Criteria) this;
        }

        public Criteria andBrandnameLike(String value) {
            addCriterion("brandName like", value, "brandname");
            return (Criteria) this;
        }

        public Criteria andBrandnameNotLike(String value) {
            addCriterion("brandName not like", value, "brandname");
            return (Criteria) this;
        }

        public Criteria andBrandnameIn(List<String> values) {
            addCriterion("brandName in", values, "brandname");
            return (Criteria) this;
        }

        public Criteria andBrandnameNotIn(List<String> values) {
            addCriterion("brandName not in", values, "brandname");
            return (Criteria) this;
        }

        public Criteria andBrandnameBetween(String value1, String value2) {
            addCriterion("brandName between", value1, value2, "brandname");
            return (Criteria) this;
        }

        public Criteria andBrandnameNotBetween(String value1, String value2) {
            addCriterion("brandName not between", value1, value2, "brandname");
            return (Criteria) this;
        }

        public Criteria andCommoditynamebakIsNull() {
            addCriterion("commodityNameBak is null");
            return (Criteria) this;
        }

        public Criteria andCommoditynamebakIsNotNull() {
            addCriterion("commodityNameBak is not null");
            return (Criteria) this;
        }

        public Criteria andCommoditynamebakEqualTo(String value) {
            addCriterion("commodityNameBak =", value, "commoditynamebak");
            return (Criteria) this;
        }

        public Criteria andCommoditynamebakNotEqualTo(String value) {
            addCriterion("commodityNameBak <>", value, "commoditynamebak");
            return (Criteria) this;
        }

        public Criteria andCommoditynamebakGreaterThan(String value) {
            addCriterion("commodityNameBak >", value, "commoditynamebak");
            return (Criteria) this;
        }

        public Criteria andCommoditynamebakGreaterThanOrEqualTo(String value) {
            addCriterion("commodityNameBak >=", value, "commoditynamebak");
            return (Criteria) this;
        }

        public Criteria andCommoditynamebakLessThan(String value) {
            addCriterion("commodityNameBak <", value, "commoditynamebak");
            return (Criteria) this;
        }

        public Criteria andCommoditynamebakLessThanOrEqualTo(String value) {
            addCriterion("commodityNameBak <=", value, "commoditynamebak");
            return (Criteria) this;
        }

        public Criteria andCommoditynamebakLike(String value) {
            addCriterion("commodityNameBak like", value, "commoditynamebak");
            return (Criteria) this;
        }

        public Criteria andCommoditynamebakNotLike(String value) {
            addCriterion("commodityNameBak not like", value, "commoditynamebak");
            return (Criteria) this;
        }

        public Criteria andCommoditynamebakIn(List<String> values) {
            addCriterion("commodityNameBak in", values, "commoditynamebak");
            return (Criteria) this;
        }

        public Criteria andCommoditynamebakNotIn(List<String> values) {
            addCriterion("commodityNameBak not in", values, "commoditynamebak");
            return (Criteria) this;
        }

        public Criteria andCommoditynamebakBetween(String value1, String value2) {
            addCriterion("commodityNameBak between", value1, value2, "commoditynamebak");
            return (Criteria) this;
        }

        public Criteria andCommoditynamebakNotBetween(String value1, String value2) {
            addCriterion("commodityNameBak not between", value1, value2, "commoditynamebak");
            return (Criteria) this;
        }

        public Criteria andTestflagIsNull() {
            addCriterion("testFlag is null");
            return (Criteria) this;
        }

        public Criteria andTestflagIsNotNull() {
            addCriterion("testFlag is not null");
            return (Criteria) this;
        }

        public Criteria andTestflagEqualTo(Integer value) {
            addCriterion("testFlag =", value, "testflag");
            return (Criteria) this;
        }

        public Criteria andTestflagNotEqualTo(Integer value) {
            addCriterion("testFlag <>", value, "testflag");
            return (Criteria) this;
        }

        public Criteria andTestflagGreaterThan(Integer value) {
            addCriterion("testFlag >", value, "testflag");
            return (Criteria) this;
        }

        public Criteria andTestflagGreaterThanOrEqualTo(Integer value) {
            addCriterion("testFlag >=", value, "testflag");
            return (Criteria) this;
        }

        public Criteria andTestflagLessThan(Integer value) {
            addCriterion("testFlag <", value, "testflag");
            return (Criteria) this;
        }

        public Criteria andTestflagLessThanOrEqualTo(Integer value) {
            addCriterion("testFlag <=", value, "testflag");
            return (Criteria) this;
        }

        public Criteria andTestflagIn(List<Integer> values) {
            addCriterion("testFlag in", values, "testflag");
            return (Criteria) this;
        }

        public Criteria andTestflagNotIn(List<Integer> values) {
            addCriterion("testFlag not in", values, "testflag");
            return (Criteria) this;
        }

        public Criteria andTestflagBetween(Integer value1, Integer value2) {
            addCriterion("testFlag between", value1, value2, "testflag");
            return (Criteria) this;
        }

        public Criteria andTestflagNotBetween(Integer value1, Integer value2) {
            addCriterion("testFlag not between", value1, value2, "testflag");
            return (Criteria) this;
        }

        public Criteria andFgpriceIsNull() {
            addCriterion("fgPrice is null");
            return (Criteria) this;
        }

        public Criteria andFgpriceIsNotNull() {
            addCriterion("fgPrice is not null");
            return (Criteria) this;
        }

        public Criteria andFgpriceEqualTo(Integer value) {
            addCriterion("fgPrice =", value, "fgprice");
            return (Criteria) this;
        }

        public Criteria andFgpriceNotEqualTo(Integer value) {
            addCriterion("fgPrice <>", value, "fgprice");
            return (Criteria) this;
        }

        public Criteria andFgpriceGreaterThan(Integer value) {
            addCriterion("fgPrice >", value, "fgprice");
            return (Criteria) this;
        }

        public Criteria andFgpriceGreaterThanOrEqualTo(Integer value) {
            addCriterion("fgPrice >=", value, "fgprice");
            return (Criteria) this;
        }

        public Criteria andFgpriceLessThan(Integer value) {
            addCriterion("fgPrice <", value, "fgprice");
            return (Criteria) this;
        }

        public Criteria andFgpriceLessThanOrEqualTo(Integer value) {
            addCriterion("fgPrice <=", value, "fgprice");
            return (Criteria) this;
        }

        public Criteria andFgpriceIn(List<Integer> values) {
            addCriterion("fgPrice in", values, "fgprice");
            return (Criteria) this;
        }

        public Criteria andFgpriceNotIn(List<Integer> values) {
            addCriterion("fgPrice not in", values, "fgprice");
            return (Criteria) this;
        }

        public Criteria andFgpriceBetween(Integer value1, Integer value2) {
            addCriterion("fgPrice between", value1, value2, "fgprice");
            return (Criteria) this;
        }

        public Criteria andFgpriceNotBetween(Integer value1, Integer value2) {
            addCriterion("fgPrice not between", value1, value2, "fgprice");
            return (Criteria) this;
        }

        public Criteria andCategory3IsNull() {
            addCriterion("category3 is null");
            return (Criteria) this;
        }

        public Criteria andCategory3IsNotNull() {
            addCriterion("category3 is not null");
            return (Criteria) this;
        }

        public Criteria andCategory3EqualTo(String value) {
            addCriterion("category3 =", value, "category3");
            return (Criteria) this;
        }

        public Criteria andCategory3NotEqualTo(String value) {
            addCriterion("category3 <>", value, "category3");
            return (Criteria) this;
        }

        public Criteria andCategory3GreaterThan(String value) {
            addCriterion("category3 >", value, "category3");
            return (Criteria) this;
        }

        public Criteria andCategory3GreaterThanOrEqualTo(String value) {
            addCriterion("category3 >=", value, "category3");
            return (Criteria) this;
        }

        public Criteria andCategory3LessThan(String value) {
            addCriterion("category3 <", value, "category3");
            return (Criteria) this;
        }

        public Criteria andCategory3LessThanOrEqualTo(String value) {
            addCriterion("category3 <=", value, "category3");
            return (Criteria) this;
        }

        public Criteria andCategory3Like(String value) {
            addCriterion("category3 like", value, "category3");
            return (Criteria) this;
        }

        public Criteria andCategory3NotLike(String value) {
            addCriterion("category3 not like", value, "category3");
            return (Criteria) this;
        }

        public Criteria andCategory3In(List<String> values) {
            addCriterion("category3 in", values, "category3");
            return (Criteria) this;
        }

        public Criteria andCategory3NotIn(List<String> values) {
            addCriterion("category3 not in", values, "category3");
            return (Criteria) this;
        }

        public Criteria andCategory3Between(String value1, String value2) {
            addCriterion("category3 between", value1, value2, "category3");
            return (Criteria) this;
        }

        public Criteria andCategory3NotBetween(String value1, String value2) {
            addCriterion("category3 not between", value1, value2, "category3");
            return (Criteria) this;
        }

        public Criteria andTaobaopriceurlIsNull() {
            addCriterion("taobaoPriceUrl is null");
            return (Criteria) this;
        }

        public Criteria andTaobaopriceurlIsNotNull() {
            addCriterion("taobaoPriceUrl is not null");
            return (Criteria) this;
        }

        public Criteria andTaobaopriceurlEqualTo(String value) {
            addCriterion("taobaoPriceUrl =", value, "taobaopriceurl");
            return (Criteria) this;
        }

        public Criteria andTaobaopriceurlNotEqualTo(String value) {
            addCriterion("taobaoPriceUrl <>", value, "taobaopriceurl");
            return (Criteria) this;
        }

        public Criteria andTaobaopriceurlGreaterThan(String value) {
            addCriterion("taobaoPriceUrl >", value, "taobaopriceurl");
            return (Criteria) this;
        }

        public Criteria andTaobaopriceurlGreaterThanOrEqualTo(String value) {
            addCriterion("taobaoPriceUrl >=", value, "taobaopriceurl");
            return (Criteria) this;
        }

        public Criteria andTaobaopriceurlLessThan(String value) {
            addCriterion("taobaoPriceUrl <", value, "taobaopriceurl");
            return (Criteria) this;
        }

        public Criteria andTaobaopriceurlLessThanOrEqualTo(String value) {
            addCriterion("taobaoPriceUrl <=", value, "taobaopriceurl");
            return (Criteria) this;
        }

        public Criteria andTaobaopriceurlLike(String value) {
            addCriterion("taobaoPriceUrl like", value, "taobaopriceurl");
            return (Criteria) this;
        }

        public Criteria andTaobaopriceurlNotLike(String value) {
            addCriterion("taobaoPriceUrl not like", value, "taobaopriceurl");
            return (Criteria) this;
        }

        public Criteria andTaobaopriceurlIn(List<String> values) {
            addCriterion("taobaoPriceUrl in", values, "taobaopriceurl");
            return (Criteria) this;
        }

        public Criteria andTaobaopriceurlNotIn(List<String> values) {
            addCriterion("taobaoPriceUrl not in", values, "taobaopriceurl");
            return (Criteria) this;
        }

        public Criteria andTaobaopriceurlBetween(String value1, String value2) {
            addCriterion("taobaoPriceUrl between", value1, value2, "taobaopriceurl");
            return (Criteria) this;
        }

        public Criteria andTaobaopriceurlNotBetween(String value1, String value2) {
            addCriterion("taobaoPriceUrl not between", value1, value2, "taobaopriceurl");
            return (Criteria) this;
        }

        public Criteria andJdpriceurlIsNull() {
            addCriterion("jdPriceUrl is null");
            return (Criteria) this;
        }

        public Criteria andJdpriceurlIsNotNull() {
            addCriterion("jdPriceUrl is not null");
            return (Criteria) this;
        }

        public Criteria andJdpriceurlEqualTo(String value) {
            addCriterion("jdPriceUrl =", value, "jdpriceurl");
            return (Criteria) this;
        }

        public Criteria andJdpriceurlNotEqualTo(String value) {
            addCriterion("jdPriceUrl <>", value, "jdpriceurl");
            return (Criteria) this;
        }

        public Criteria andJdpriceurlGreaterThan(String value) {
            addCriterion("jdPriceUrl >", value, "jdpriceurl");
            return (Criteria) this;
        }

        public Criteria andJdpriceurlGreaterThanOrEqualTo(String value) {
            addCriterion("jdPriceUrl >=", value, "jdpriceurl");
            return (Criteria) this;
        }

        public Criteria andJdpriceurlLessThan(String value) {
            addCriterion("jdPriceUrl <", value, "jdpriceurl");
            return (Criteria) this;
        }

        public Criteria andJdpriceurlLessThanOrEqualTo(String value) {
            addCriterion("jdPriceUrl <=", value, "jdpriceurl");
            return (Criteria) this;
        }

        public Criteria andJdpriceurlLike(String value) {
            addCriterion("jdPriceUrl like", value, "jdpriceurl");
            return (Criteria) this;
        }

        public Criteria andJdpriceurlNotLike(String value) {
            addCriterion("jdPriceUrl not like", value, "jdpriceurl");
            return (Criteria) this;
        }

        public Criteria andJdpriceurlIn(List<String> values) {
            addCriterion("jdPriceUrl in", values, "jdpriceurl");
            return (Criteria) this;
        }

        public Criteria andJdpriceurlNotIn(List<String> values) {
            addCriterion("jdPriceUrl not in", values, "jdpriceurl");
            return (Criteria) this;
        }

        public Criteria andJdpriceurlBetween(String value1, String value2) {
            addCriterion("jdPriceUrl between", value1, value2, "jdpriceurl");
            return (Criteria) this;
        }

        public Criteria andJdpriceurlNotBetween(String value1, String value2) {
            addCriterion("jdPriceUrl not between", value1, value2, "jdpriceurl");
            return (Criteria) this;
        }

        public Criteria andTmallpriceurlIsNull() {
            addCriterion("tmallPriceUrl is null");
            return (Criteria) this;
        }

        public Criteria andTmallpriceurlIsNotNull() {
            addCriterion("tmallPriceUrl is not null");
            return (Criteria) this;
        }

        public Criteria andTmallpriceurlEqualTo(String value) {
            addCriterion("tmallPriceUrl =", value, "tmallpriceurl");
            return (Criteria) this;
        }

        public Criteria andTmallpriceurlNotEqualTo(String value) {
            addCriterion("tmallPriceUrl <>", value, "tmallpriceurl");
            return (Criteria) this;
        }

        public Criteria andTmallpriceurlGreaterThan(String value) {
            addCriterion("tmallPriceUrl >", value, "tmallpriceurl");
            return (Criteria) this;
        }

        public Criteria andTmallpriceurlGreaterThanOrEqualTo(String value) {
            addCriterion("tmallPriceUrl >=", value, "tmallpriceurl");
            return (Criteria) this;
        }

        public Criteria andTmallpriceurlLessThan(String value) {
            addCriterion("tmallPriceUrl <", value, "tmallpriceurl");
            return (Criteria) this;
        }

        public Criteria andTmallpriceurlLessThanOrEqualTo(String value) {
            addCriterion("tmallPriceUrl <=", value, "tmallpriceurl");
            return (Criteria) this;
        }

        public Criteria andTmallpriceurlLike(String value) {
            addCriterion("tmallPriceUrl like", value, "tmallpriceurl");
            return (Criteria) this;
        }

        public Criteria andTmallpriceurlNotLike(String value) {
            addCriterion("tmallPriceUrl not like", value, "tmallpriceurl");
            return (Criteria) this;
        }

        public Criteria andTmallpriceurlIn(List<String> values) {
            addCriterion("tmallPriceUrl in", values, "tmallpriceurl");
            return (Criteria) this;
        }

        public Criteria andTmallpriceurlNotIn(List<String> values) {
            addCriterion("tmallPriceUrl not in", values, "tmallpriceurl");
            return (Criteria) this;
        }

        public Criteria andTmallpriceurlBetween(String value1, String value2) {
            addCriterion("tmallPriceUrl between", value1, value2, "tmallpriceurl");
            return (Criteria) this;
        }

        public Criteria andTmallpriceurlNotBetween(String value1, String value2) {
            addCriterion("tmallPriceUrl not between", value1, value2, "tmallpriceurl");
            return (Criteria) this;
        }

        public Criteria andBenchmarkingpriceIsNull() {
            addCriterion("benchmarkingPrice is null");
            return (Criteria) this;
        }

        public Criteria andBenchmarkingpriceIsNotNull() {
            addCriterion("benchmarkingPrice is not null");
            return (Criteria) this;
        }

        public Criteria andBenchmarkingpriceEqualTo(Integer value) {
            addCriterion("benchmarkingPrice =", value, "benchmarkingprice");
            return (Criteria) this;
        }

        public Criteria andBenchmarkingpriceNotEqualTo(Integer value) {
            addCriterion("benchmarkingPrice <>", value, "benchmarkingprice");
            return (Criteria) this;
        }

        public Criteria andBenchmarkingpriceGreaterThan(Integer value) {
            addCriterion("benchmarkingPrice >", value, "benchmarkingprice");
            return (Criteria) this;
        }

        public Criteria andBenchmarkingpriceGreaterThanOrEqualTo(Integer value) {
            addCriterion("benchmarkingPrice >=", value, "benchmarkingprice");
            return (Criteria) this;
        }

        public Criteria andBenchmarkingpriceLessThan(Integer value) {
            addCriterion("benchmarkingPrice <", value, "benchmarkingprice");
            return (Criteria) this;
        }

        public Criteria andBenchmarkingpriceLessThanOrEqualTo(Integer value) {
            addCriterion("benchmarkingPrice <=", value, "benchmarkingprice");
            return (Criteria) this;
        }

        public Criteria andBenchmarkingpriceIn(List<Integer> values) {
            addCriterion("benchmarkingPrice in", values, "benchmarkingprice");
            return (Criteria) this;
        }

        public Criteria andBenchmarkingpriceNotIn(List<Integer> values) {
            addCriterion("benchmarkingPrice not in", values, "benchmarkingprice");
            return (Criteria) this;
        }

        public Criteria andBenchmarkingpriceBetween(Integer value1, Integer value2) {
            addCriterion("benchmarkingPrice between", value1, value2, "benchmarkingprice");
            return (Criteria) this;
        }

        public Criteria andBenchmarkingpriceNotBetween(Integer value1, Integer value2) {
            addCriterion("benchmarkingPrice not between", value1, value2, "benchmarkingprice");
            return (Criteria) this;
        }

        public Criteria andIsproxyIsNull() {
            addCriterion("isProxy is null");
            return (Criteria) this;
        }

        public Criteria andIsproxyIsNotNull() {
            addCriterion("isProxy is not null");
            return (Criteria) this;
        }

        public Criteria andIsproxyEqualTo(Byte value) {
            addCriterion("isProxy =", value, "isproxy");
            return (Criteria) this;
        }

        public Criteria andIsproxyNotEqualTo(Byte value) {
            addCriterion("isProxy <>", value, "isproxy");
            return (Criteria) this;
        }

        public Criteria andIsproxyGreaterThan(Byte value) {
            addCriterion("isProxy >", value, "isproxy");
            return (Criteria) this;
        }

        public Criteria andIsproxyGreaterThanOrEqualTo(Byte value) {
            addCriterion("isProxy >=", value, "isproxy");
            return (Criteria) this;
        }

        public Criteria andIsproxyLessThan(Byte value) {
            addCriterion("isProxy <", value, "isproxy");
            return (Criteria) this;
        }

        public Criteria andIsproxyLessThanOrEqualTo(Byte value) {
            addCriterion("isProxy <=", value, "isproxy");
            return (Criteria) this;
        }

        public Criteria andIsproxyIn(List<Byte> values) {
            addCriterion("isProxy in", values, "isproxy");
            return (Criteria) this;
        }

        public Criteria andIsproxyNotIn(List<Byte> values) {
            addCriterion("isProxy not in", values, "isproxy");
            return (Criteria) this;
        }

        public Criteria andIsproxyBetween(Byte value1, Byte value2) {
            addCriterion("isProxy between", value1, value2, "isproxy");
            return (Criteria) this;
        }

        public Criteria andIsproxyNotBetween(Byte value1, Byte value2) {
            addCriterion("isProxy not between", value1, value2, "isproxy");
            return (Criteria) this;
        }

        public Criteria andProxycommissionIsNull() {
            addCriterion("proxyCommission is null");
            return (Criteria) this;
        }

        public Criteria andProxycommissionIsNotNull() {
            addCriterion("proxyCommission is not null");
            return (Criteria) this;
        }

        public Criteria andProxycommissionEqualTo(Integer value) {
            addCriterion("proxyCommission =", value, "proxycommission");
            return (Criteria) this;
        }

        public Criteria andProxycommissionNotEqualTo(Integer value) {
            addCriterion("proxyCommission <>", value, "proxycommission");
            return (Criteria) this;
        }

        public Criteria andProxycommissionGreaterThan(Integer value) {
            addCriterion("proxyCommission >", value, "proxycommission");
            return (Criteria) this;
        }

        public Criteria andProxycommissionGreaterThanOrEqualTo(Integer value) {
            addCriterion("proxyCommission >=", value, "proxycommission");
            return (Criteria) this;
        }

        public Criteria andProxycommissionLessThan(Integer value) {
            addCriterion("proxyCommission <", value, "proxycommission");
            return (Criteria) this;
        }

        public Criteria andProxycommissionLessThanOrEqualTo(Integer value) {
            addCriterion("proxyCommission <=", value, "proxycommission");
            return (Criteria) this;
        }

        public Criteria andProxycommissionIn(List<Integer> values) {
            addCriterion("proxyCommission in", values, "proxycommission");
            return (Criteria) this;
        }

        public Criteria andProxycommissionNotIn(List<Integer> values) {
            addCriterion("proxyCommission not in", values, "proxycommission");
            return (Criteria) this;
        }

        public Criteria andProxycommissionBetween(Integer value1, Integer value2) {
            addCriterion("proxyCommission between", value1, value2, "proxycommission");
            return (Criteria) this;
        }

        public Criteria andProxycommissionNotBetween(Integer value1, Integer value2) {
            addCriterion("proxyCommission not between", value1, value2, "proxycommission");
            return (Criteria) this;
        }

        public Criteria andDescriptionIsNull() {
            addCriterion("description is null");
            return (Criteria) this;
        }

        public Criteria andDescriptionIsNotNull() {
            addCriterion("description is not null");
            return (Criteria) this;
        }

        public Criteria andDescriptionEqualTo(String value) {
            addCriterion("description =", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionNotEqualTo(String value) {
            addCriterion("description <>", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionGreaterThan(String value) {
            addCriterion("description >", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionGreaterThanOrEqualTo(String value) {
            addCriterion("description >=", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionLessThan(String value) {
            addCriterion("description <", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionLessThanOrEqualTo(String value) {
            addCriterion("description <=", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionLike(String value) {
            addCriterion("description like", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionNotLike(String value) {
            addCriterion("description not like", value, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionIn(List<String> values) {
            addCriterion("description in", values, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionNotIn(List<String> values) {
            addCriterion("description not in", values, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionBetween(String value1, String value2) {
            addCriterion("description between", value1, value2, "description");
            return (Criteria) this;
        }

        public Criteria andDescriptionNotBetween(String value1, String value2) {
            addCriterion("description not between", value1, value2, "description");
            return (Criteria) this;
        }

        public Criteria andRecommendationIsNull() {
            addCriterion("recommendation is null");
            return (Criteria) this;
        }

        public Criteria andRecommendationIsNotNull() {
            addCriterion("recommendation is not null");
            return (Criteria) this;
        }

        public Criteria andRecommendationEqualTo(Boolean value) {
            addCriterion("recommendation =", value, "recommendation");
            return (Criteria) this;
        }

        public Criteria andRecommendationNotEqualTo(Boolean value) {
            addCriterion("recommendation <>", value, "recommendation");
            return (Criteria) this;
        }

        public Criteria andRecommendationGreaterThan(Boolean value) {
            addCriterion("recommendation >", value, "recommendation");
            return (Criteria) this;
        }

        public Criteria andRecommendationGreaterThanOrEqualTo(Boolean value) {
            addCriterion("recommendation >=", value, "recommendation");
            return (Criteria) this;
        }

        public Criteria andRecommendationLessThan(Boolean value) {
            addCriterion("recommendation <", value, "recommendation");
            return (Criteria) this;
        }

        public Criteria andRecommendationLessThanOrEqualTo(Boolean value) {
            addCriterion("recommendation <=", value, "recommendation");
            return (Criteria) this;
        }

        public Criteria andRecommendationIn(List<Boolean> values) {
            addCriterion("recommendation in", values, "recommendation");
            return (Criteria) this;
        }

        public Criteria andRecommendationNotIn(List<Boolean> values) {
            addCriterion("recommendation not in", values, "recommendation");
            return (Criteria) this;
        }

        public Criteria andRecommendationBetween(Boolean value1, Boolean value2) {
            addCriterion("recommendation between", value1, value2, "recommendation");
            return (Criteria) this;
        }

        public Criteria andRecommendationNotBetween(Boolean value1, Boolean value2) {
            addCriterion("recommendation not between", value1, value2, "recommendation");
            return (Criteria) this;
        }

        public Criteria andIsshareIsNull() {
            addCriterion("isShare is null");
            return (Criteria) this;
        }

        public Criteria andIsshareIsNotNull() {
            addCriterion("isShare is not null");
            return (Criteria) this;
        }

        public Criteria andIsshareEqualTo(Byte value) {
            addCriterion("isShare =", value, "isshare");
            return (Criteria) this;
        }

        public Criteria andIsshareNotEqualTo(Byte value) {
            addCriterion("isShare <>", value, "isshare");
            return (Criteria) this;
        }

        public Criteria andIsshareGreaterThan(Byte value) {
            addCriterion("isShare >", value, "isshare");
            return (Criteria) this;
        }

        public Criteria andIsshareGreaterThanOrEqualTo(Byte value) {
            addCriterion("isShare >=", value, "isshare");
            return (Criteria) this;
        }

        public Criteria andIsshareLessThan(Byte value) {
            addCriterion("isShare <", value, "isshare");
            return (Criteria) this;
        }

        public Criteria andIsshareLessThanOrEqualTo(Byte value) {
            addCriterion("isShare <=", value, "isshare");
            return (Criteria) this;
        }

        public Criteria andIsshareIn(List<Byte> values) {
            addCriterion("isShare in", values, "isshare");
            return (Criteria) this;
        }

        public Criteria andIsshareNotIn(List<Byte> values) {
            addCriterion("isShare not in", values, "isshare");
            return (Criteria) this;
        }

        public Criteria andIsshareBetween(Byte value1, Byte value2) {
            addCriterion("isShare between", value1, value2, "isshare");
            return (Criteria) this;
        }

        public Criteria andIsshareNotBetween(Byte value1, Byte value2) {
            addCriterion("isShare not between", value1, value2, "isshare");
            return (Criteria) this;
        }

        public Criteria andSharecommissionIsNull() {
            addCriterion("shareCommission is null");
            return (Criteria) this;
        }

        public Criteria andSharecommissionIsNotNull() {
            addCriterion("shareCommission is not null");
            return (Criteria) this;
        }

        public Criteria andSharecommissionEqualTo(Integer value) {
            addCriterion("shareCommission =", value, "sharecommission");
            return (Criteria) this;
        }

        public Criteria andSharecommissionNotEqualTo(Integer value) {
            addCriterion("shareCommission <>", value, "sharecommission");
            return (Criteria) this;
        }

        public Criteria andSharecommissionGreaterThan(Integer value) {
            addCriterion("shareCommission >", value, "sharecommission");
            return (Criteria) this;
        }

        public Criteria andSharecommissionGreaterThanOrEqualTo(Integer value) {
            addCriterion("shareCommission >=", value, "sharecommission");
            return (Criteria) this;
        }

        public Criteria andSharecommissionLessThan(Integer value) {
            addCriterion("shareCommission <", value, "sharecommission");
            return (Criteria) this;
        }

        public Criteria andSharecommissionLessThanOrEqualTo(Integer value) {
            addCriterion("shareCommission <=", value, "sharecommission");
            return (Criteria) this;
        }

        public Criteria andSharecommissionIn(List<Integer> values) {
            addCriterion("shareCommission in", values, "sharecommission");
            return (Criteria) this;
        }

        public Criteria andSharecommissionNotIn(List<Integer> values) {
            addCriterion("shareCommission not in", values, "sharecommission");
            return (Criteria) this;
        }

        public Criteria andSharecommissionBetween(Integer value1, Integer value2) {
            addCriterion("shareCommission between", value1, value2, "sharecommission");
            return (Criteria) this;
        }

        public Criteria andSharecommissionNotBetween(Integer value1, Integer value2) {
            addCriterion("shareCommission not between", value1, value2, "sharecommission");
            return (Criteria) this;
        }

        public Criteria andSharerecommendIsNull() {
            addCriterion("shareRecommend is null");
            return (Criteria) this;
        }

        public Criteria andSharerecommendIsNotNull() {
            addCriterion("shareRecommend is not null");
            return (Criteria) this;
        }

        public Criteria andSharerecommendEqualTo(Byte value) {
            addCriterion("shareRecommend =", value, "sharerecommend");
            return (Criteria) this;
        }

        public Criteria andSharerecommendNotEqualTo(Byte value) {
            addCriterion("shareRecommend <>", value, "sharerecommend");
            return (Criteria) this;
        }

        public Criteria andSharerecommendGreaterThan(Byte value) {
            addCriterion("shareRecommend >", value, "sharerecommend");
            return (Criteria) this;
        }

        public Criteria andSharerecommendGreaterThanOrEqualTo(Byte value) {
            addCriterion("shareRecommend >=", value, "sharerecommend");
            return (Criteria) this;
        }

        public Criteria andSharerecommendLessThan(Byte value) {
            addCriterion("shareRecommend <", value, "sharerecommend");
            return (Criteria) this;
        }

        public Criteria andSharerecommendLessThanOrEqualTo(Byte value) {
            addCriterion("shareRecommend <=", value, "sharerecommend");
            return (Criteria) this;
        }

        public Criteria andSharerecommendIn(List<Byte> values) {
            addCriterion("shareRecommend in", values, "sharerecommend");
            return (Criteria) this;
        }

        public Criteria andSharerecommendNotIn(List<Byte> values) {
            addCriterion("shareRecommend not in", values, "sharerecommend");
            return (Criteria) this;
        }

        public Criteria andSharerecommendBetween(Byte value1, Byte value2) {
            addCriterion("shareRecommend between", value1, value2, "sharerecommend");
            return (Criteria) this;
        }

        public Criteria andSharerecommendNotBetween(Byte value1, Byte value2) {
            addCriterion("shareRecommend not between", value1, value2, "sharerecommend");
            return (Criteria) this;
        }

        public Criteria andCountryshopidIsNull() {
            addCriterion("countryShopId is null");
            return (Criteria) this;
        }

        public Criteria andCountryshopidIsNotNull() {
            addCriterion("countryShopId is not null");
            return (Criteria) this;
        }

        public Criteria andCountryshopidEqualTo(String value) {
            addCriterion("countryShopId =", value, "countryshopid");
            return (Criteria) this;
        }

        public Criteria andCountryshopidNotEqualTo(String value) {
            addCriterion("countryShopId <>", value, "countryshopid");
            return (Criteria) this;
        }

        public Criteria andCountryshopidGreaterThan(String value) {
            addCriterion("countryShopId >", value, "countryshopid");
            return (Criteria) this;
        }

        public Criteria andCountryshopidGreaterThanOrEqualTo(String value) {
            addCriterion("countryShopId >=", value, "countryshopid");
            return (Criteria) this;
        }

        public Criteria andCountryshopidLessThan(String value) {
            addCriterion("countryShopId <", value, "countryshopid");
            return (Criteria) this;
        }

        public Criteria andCountryshopidLessThanOrEqualTo(String value) {
            addCriterion("countryShopId <=", value, "countryshopid");
            return (Criteria) this;
        }

        public Criteria andCountryshopidLike(String value) {
            addCriterion("countryShopId like", value, "countryshopid");
            return (Criteria) this;
        }

        public Criteria andCountryshopidNotLike(String value) {
            addCriterion("countryShopId not like", value, "countryshopid");
            return (Criteria) this;
        }

        public Criteria andCountryshopidIn(List<String> values) {
            addCriterion("countryShopId in", values, "countryshopid");
            return (Criteria) this;
        }

        public Criteria andCountryshopidNotIn(List<String> values) {
            addCriterion("countryShopId not in", values, "countryshopid");
            return (Criteria) this;
        }

        public Criteria andCountryshopidBetween(String value1, String value2) {
            addCriterion("countryShopId between", value1, value2, "countryshopid");
            return (Criteria) this;
        }

        public Criteria andCountryshopidNotBetween(String value1, String value2) {
            addCriterion("countryShopId not between", value1, value2, "countryshopid");
            return (Criteria) this;
        }

        public Criteria andCommoditynamePinyinIsNull() {
            addCriterion("commodityName_pinyin is null");
            return (Criteria) this;
        }

        public Criteria andCommoditynamePinyinIsNotNull() {
            addCriterion("commodityName_pinyin is not null");
            return (Criteria) this;
        }

        public Criteria andCommoditynamePinyinEqualTo(String value) {
            addCriterion("commodityName_pinyin =", value, "commoditynamePinyin");
            return (Criteria) this;
        }

        public Criteria andCommoditynamePinyinNotEqualTo(String value) {
            addCriterion("commodityName_pinyin <>", value, "commoditynamePinyin");
            return (Criteria) this;
        }

        public Criteria andCommoditynamePinyinGreaterThan(String value) {
            addCriterion("commodityName_pinyin >", value, "commoditynamePinyin");
            return (Criteria) this;
        }

        public Criteria andCommoditynamePinyinGreaterThanOrEqualTo(String value) {
            addCriterion("commodityName_pinyin >=", value, "commoditynamePinyin");
            return (Criteria) this;
        }

        public Criteria andCommoditynamePinyinLessThan(String value) {
            addCriterion("commodityName_pinyin <", value, "commoditynamePinyin");
            return (Criteria) this;
        }

        public Criteria andCommoditynamePinyinLessThanOrEqualTo(String value) {
            addCriterion("commodityName_pinyin <=", value, "commoditynamePinyin");
            return (Criteria) this;
        }

        public Criteria andCommoditynamePinyinLike(String value) {
            addCriterion("commodityName_pinyin like", value, "commoditynamePinyin");
            return (Criteria) this;
        }

        public Criteria andCommoditynamePinyinNotLike(String value) {
            addCriterion("commodityName_pinyin not like", value, "commoditynamePinyin");
            return (Criteria) this;
        }

        public Criteria andCommoditynamePinyinIn(List<String> values) {
            addCriterion("commodityName_pinyin in", values, "commoditynamePinyin");
            return (Criteria) this;
        }

        public Criteria andCommoditynamePinyinNotIn(List<String> values) {
            addCriterion("commodityName_pinyin not in", values, "commoditynamePinyin");
            return (Criteria) this;
        }

        public Criteria andCommoditynamePinyinBetween(String value1, String value2) {
            addCriterion("commodityName_pinyin between", value1, value2, "commoditynamePinyin");
            return (Criteria) this;
        }

        public Criteria andCommoditynamePinyinNotBetween(String value1, String value2) {
            addCriterion("commodityName_pinyin not between", value1, value2, "commoditynamePinyin");
            return (Criteria) this;
        }

        public Criteria andMastercommissionIsNull() {
            addCriterion("masterCommission is null");
            return (Criteria) this;
        }

        public Criteria andMastercommissionIsNotNull() {
            addCriterion("masterCommission is not null");
            return (Criteria) this;
        }

        public Criteria andMastercommissionEqualTo(Integer value) {
            addCriterion("masterCommission =", value, "mastercommission");
            return (Criteria) this;
        }

        public Criteria andMastercommissionNotEqualTo(Integer value) {
            addCriterion("masterCommission <>", value, "mastercommission");
            return (Criteria) this;
        }

        public Criteria andMastercommissionGreaterThan(Integer value) {
            addCriterion("masterCommission >", value, "mastercommission");
            return (Criteria) this;
        }

        public Criteria andMastercommissionGreaterThanOrEqualTo(Integer value) {
            addCriterion("masterCommission >=", value, "mastercommission");
            return (Criteria) this;
        }

        public Criteria andMastercommissionLessThan(Integer value) {
            addCriterion("masterCommission <", value, "mastercommission");
            return (Criteria) this;
        }

        public Criteria andMastercommissionLessThanOrEqualTo(Integer value) {
            addCriterion("masterCommission <=", value, "mastercommission");
            return (Criteria) this;
        }

        public Criteria andMastercommissionIn(List<Integer> values) {
            addCriterion("masterCommission in", values, "mastercommission");
            return (Criteria) this;
        }

        public Criteria andMastercommissionNotIn(List<Integer> values) {
            addCriterion("masterCommission not in", values, "mastercommission");
            return (Criteria) this;
        }

        public Criteria andMastercommissionBetween(Integer value1, Integer value2) {
            addCriterion("masterCommission between", value1, value2, "mastercommission");
            return (Criteria) this;
        }

        public Criteria andMastercommissionNotBetween(Integer value1, Integer value2) {
            addCriterion("masterCommission not between", value1, value2, "mastercommission");
            return (Criteria) this;
        }

        public Criteria andAutopriceIsNull() {
            addCriterion("autoPrice is null");
            return (Criteria) this;
        }

        public Criteria andAutopriceIsNotNull() {
            addCriterion("autoPrice is not null");
            return (Criteria) this;
        }

        public Criteria andAutopriceEqualTo(Boolean value) {
            addCriterion("autoPrice =", value, "autoprice");
            return (Criteria) this;
        }

        public Criteria andAutopriceNotEqualTo(Boolean value) {
            addCriterion("autoPrice <>", value, "autoprice");
            return (Criteria) this;
        }

        public Criteria andAutopriceGreaterThan(Boolean value) {
            addCriterion("autoPrice >", value, "autoprice");
            return (Criteria) this;
        }

        public Criteria andAutopriceGreaterThanOrEqualTo(Boolean value) {
            addCriterion("autoPrice >=", value, "autoprice");
            return (Criteria) this;
        }

        public Criteria andAutopriceLessThan(Boolean value) {
            addCriterion("autoPrice <", value, "autoprice");
            return (Criteria) this;
        }

        public Criteria andAutopriceLessThanOrEqualTo(Boolean value) {
            addCriterion("autoPrice <=", value, "autoprice");
            return (Criteria) this;
        }

        public Criteria andAutopriceIn(List<Boolean> values) {
            addCriterion("autoPrice in", values, "autoprice");
            return (Criteria) this;
        }

        public Criteria andAutopriceNotIn(List<Boolean> values) {
            addCriterion("autoPrice not in", values, "autoprice");
            return (Criteria) this;
        }

        public Criteria andAutopriceBetween(Boolean value1, Boolean value2) {
            addCriterion("autoPrice between", value1, value2, "autoprice");
            return (Criteria) this;
        }

        public Criteria andAutopriceNotBetween(Boolean value1, Boolean value2) {
            addCriterion("autoPrice not between", value1, value2, "autoprice");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}